package com.ocom.payhandle.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.card.EntityXfMealTime;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface IDaoXfMealTime extends BaseMapper<EntityXfMealTime> {

	@Select({"<script>",
			"select  a.meal_name,b.*  \n" +
					"FROM xf_meal_info a \n" +
					"LEFT JOIN xf_meal_time b ON a.com_id=b.com_id AND a.meal_no=b.meal_no \n" +
					"where a.com_id=#{comId} " +
					"</script>"})
	List<EntityXfMealTime> getMealInfo(@Param("comId")Long comId);

}
